A foreign key specifies that the values in a column (or a group of columns) must match the values appearing in some row of another table. We say this maintains the referential integrity between two related tables.
Foreign Keys are managed on the Foreign Keys tab of the Table Designer. Just simply click a foreign key field for editing. By using the toolbar below, you can create new, edit and delete the selected foreign key field.
Add Foreign Key
To add a foreign key
- Open the table in the Table Designer.
- Open the Foreign Keys tab.
- Click the
Add Foreign Key from the toolbar.
- Edit foreign key properties.
Edit Foreign Key
To edit a foreign key
- Open the table in the Table Designer.
- Open the Foreign Keys tab.
- Click on the foreign key to edit.
Delete Foreign Key
To delete a foreign key
- Open the table in the Table Designer.
- Open the Foreign Keys tab.
- Click the
Delete Foreign Key from the toolbar.
- Confirm deleting in the dialog window.
See also:
Setting Foreign Key Properties
Related topic:
Foreign Keys Data Selection